package com.shop.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shop.pojo.pms.Pms_Brand;
import org.apache.ibatis.annotations.Select;

import java.util.List;

//商品品牌表
public interface Pms_Brand_Mapper extends BaseMapper<Pms_Brand> {

    //查询当前分类下的全部品牌信息
@Select("select * from pms_brand where brand_id in(select brand_id from pms_category_brand_relation where catelog_id=#{catelog_id})")
    List<Pms_Brand> findAllBrandByCatalogId(Integer catelog_id);
}
